﻿



-- 监视点设备信息新增
CREATE procedure [dbo].[JsdsbInfo_Add]
@jsdbh varchar(18),
@sblsh int,
@sfkqkq bit,
@sfkqjs bit
as
if not exists(select 1 from Jsdsb_Info where jsdbh=@jsdbh and sblsh=@sblsh)
begin
-- 添加监视点设备
insert into Jsdsb_Info(jsdbh,sblsh,sfkqkq,sfkqjs) values(@jsdbh,@sblsh,@sfkqkq,@sfkqjs)
select @@identity
end